package com.cloudfun.campusshare.repo.sql;


public class SqlOrderRefund {
    public final static String REFUND_SETTLEMENT_STATISTICS = "SELECT pay_platform,merchant_id,SUM( price ) as price,date_format( refund_time, '%Y-%m-%d' ) AS refundTime FROM order_refund" +
            " WHERE" +
            " order_status='REFUND' " +
            " and refund_review = 'SUCCESS' " +
            " GROUP BY" +
            " pay_platform,merchant_id" +
            " HAVING refundTime='{}'";
}
